Select DISTINCT(yr) from (select year(issue_date) as yr, issue_date from printsize_master,np_master,stamps where issue_date!='' and  printsize_master.printsize_code=stamps.printsize_code and printsize_master.printsize='4.48 X 3.3'  and np_master.np_code=stamps.np_code and np_master.np='P'  and stamps.serial_no='1402'  order by issue_date) t